Pizza Sales Analysis using SQL

Project Overview

This project focuses on analyzing pizza sales data using SQL to uncover key trends and business insights. The goal is to understand customer behavior, identify revenue-driving factors, and provide actionable recommendations to enhance the store’s sales performance. By leveraging SQL queries, we explore order patterns, revenue breakdowns, and sales trends across different pizza types, sizes, and time periods. This data-driven approach helps in making informed business decisions to optimize operations, pricing strategies, and promotional efforts.

Key Insights

• Total Orders: Measured the overall number of orders placed to gauge demand.
• Order Frequency: Identified peak days and trends in customer purchasing behavior.
• Total Sales: Analyzed the total revenue generated from all pizza orders.
• Average Order Value: Determined how much customers typically spend per order.
• Daily Revenue Trends: Tracked revenue fluctuations over different days.
• Revenue per Pizza Type: Evaluated which pizza types contributed the most to sales.
• Pizza Popularity Ranking: Identified the best-selling pizzas.
• Sales Comparison (Weekdays vs. Weekends): Found that weekday sales are nearly double those of weekends.
• Pizza Size Analysis: Large pizzas contribute the most to revenue, while extra-large pizzas are the least popular.
• Least Sold Category: Chicken pizzas recorded the lowest sales.

Technical Implementation

Data Processing & SQL Queries:

• Database Setup: Loaded the pizza sales dataset into a SQL database.
• Data Cleaning: Ensured data consistency and removed anomalies.

SQL Queries Used:

• Aggregation functions (SUM, AVG, COUNT) for sales and revenue calculations.
• GROUP BY and ORDER BY to analyze trends across different categories.
• JOIN operations to combine multiple tables for comprehensive analysis.
• Subqueries to extract meaningful insights.

Key Learnings

• SQL is a powerful tool for extracting business insights from structured data.
• Analyzing order frequency helps identify peak business hours for better staff allocation.
• Large pizzas drive the most revenue, making them a priority for promotions.
• Chicken pizzas underperform, indicating a need for customer feedback and menu adjustments.
• Weekday sales outperform weekend sales, suggesting potential for targeted weekend promotions.
• Inventory management plays a crucial role in ensuring high-demand pizzas remain available.